Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
ItemTenderRestrictionGroupCode (FK)(PK) | A retailer assigned code to denote a specific group of ItemTenderRestrictions. | LU_GP_TND_RST | Code2 | char(2) | ItemTenderRestrictionGroup(CO_RST_ITM_TND) |
Name | The rule that prohibits the purchase of certain Items by certain tender types. | NM_RU_TND_RST | Name | varchar(40) | |
Description | A description of the rule that prohibits the purchase of specific Items with certain tender types. | DE_RU_TND_RST | DescriptionShort | varchar(255) | |
ThresholdAmount | A monetary amount at which this restriction tender rule applies. | MO_AMT_THRSH | MoneyShortRetail | decimal(7,2) | |
EffectiveDate | The date from which the restriction rule applies. | DC_RST_TND_EF | EffectiveDate | date | |
ExpirationDate | The date until which the restriction rule applies. | DC_RST_TND_EP | ExpirationDate | date | |
StatusCode | A code to indicate whether the restriction rule applies to a certain Item or not. | SC_RU_TND_RST | Code2Status | char(2) | |